Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
OperatorID (FK)(PK) | A unique, automatically assigned number used to identify a workstation OPERATOR. | ID_OPR | Identity | integer | Operator(PA_OPR) |
BusinessUnitID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_BSN_UN | Identity | integer | BusinessUnit(LO_BSN_UN) |
EffectiveDateTime (PK) | The date & time from which the assignment is valid. | TS_EF | EffectiveDateTime | datetime | |
ExpirationDateTime | The date & time until which the assignment is valid. | TS_EP | ExpirationDateTime | datetime | |
OperatorNumber | A locally unique identifier for the Operator while they are assigned to the nominated BusinessUnit. | NU_OPR | Identity | integer | |